package com.example.dao;

import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import com.example.entity.DrawingMaterial;
import com.example.entity.Material2;
@Mapper
public interface UxmadsMapper {

	public int insert_Uxmads(@Param("list") List<DrawingMaterial> list, @Param("projectNumber")Integer projectNumber);

	public int insert_Uxmads_lieitem(@Param("list") List<Material2> list,@Param("Id")  Integer  Id);

	public int insert_Uxmads_perm(List<DrawingMaterial> list);

	public Integer select_unifier_uxmads_MaxId();

	public Integer select_unifier_uxmads_lieitem_MaxId();

	
	public List<String>	select_unifier_uxmads_Drawing_No(@Param("type")String type,@Param("projectNumber") Integer  projectNumber);
	
	/**
	 * 查询 母材与余料信息
	 * @return
	 */
	public List<Map<String, String>> select_uxmads_lieitem_remnant_bulk( @Param("projectNumber") Integer  projectNumber );



	/**
	 * 查询  图纸的详细物料信息
	 * @return
	 */
	public List<Map<String, String>> select_uxmads_lieitem_Drawing_Material( @Param("projectNumber") Integer  projectNumber ,@Param("drawingNo") String drawingNo,
			@Param("Rev") String Rev);









}
